Page 1 of 3 123 LastLast
Results 1 to 15 of 32
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts
    MS Access 2007
    Outlook 2007
    I have an access database from which I would like to send a mail out to recipients to have them check a specific records details.
    In Access I have all but completed the procedure which uses the /cmd switch to pass known variable on opening the database.

    The difficulty now comes when sending the shortcut to the recipient in form of e-mail via outlook.

    the shortcut format is same as a shortcut link with the relevant /cmd switch and variable:
    "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "S:\Databases\FileListing.accdb" /cmd "abc123"

    But when I try and use that in outlook I don't get the formatting nor hyperlink retained correctly.

    Any pointers as to best way to go about this please?
    Thanks
    Alan

  2. #2
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts
    MS Access 2007
    Outlook 2007
    I have an access database from which I would like to send a mail out to recipients to have them check a specific records details.
    In Access I have all but completed the procedure which uses the /cmd switch to pass known variable on opening the database.

    The difficulty now comes when sending the shortcut to the recipient in form of e-mail via outlook.

    the shortcut format is same as a shortcut link with the relevant /cmd switch and variable:
    "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "S:\Databases\FileListing.accdb" /cmd "abc123"

    But when I try and use that in outlook I don't get the formatting nor hyperlink retained correctly.

    Any pointers as to best way to go about this please?
    Thanks
    Alan

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts
    MS Access 2007
    Outlook 2007
    I have an access database from which I would like to send a mail out to recipients to have them check a specific records details.
    In Access I have all but completed the procedure which uses the /cmd switch to pass known variable on opening the database.

    The difficulty now comes when sending the shortcut to the recipient in form of e-mail via outlook.

    the shortcut format is same as a shortcut link with the relevant /cmd switch and variable:
    "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "S:\Databases\FileListing.accdb" /cmd "abc123"

    But when I try and use that in outlook I don't get the formatting nor hyperlink retained correctly.

    Any pointers as to best way to go about this please?
    Thanks
    Alan

  4. #4
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts
    MS Access 2007
    Outlook 2007
    I have an access database from which I would like to send a mail out to recipients to have them check a specific records details.
    In Access I have all but completed the procedure which uses the /cmd switch to pass known variable on opening the database.

    The difficulty now comes when sending the shortcut to the recipient in form of e-mail via outlook.

    the shortcut format is same as a shortcut link with the relevant /cmd switch and variable:
    "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "S:\Databases\FileListing.accdb" /cmd "abc123"

    But when I try and use that in outlook I don't get the formatting nor hyperlink retained correctly.

    Any pointers as to best way to go about this please?
    Thanks
    Alan

  5. #5
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts
    MS Access 2007
    Outlook 2007
    I have an access database from which I would like to send a mail out to recipients to have them check a specific records details.
    In Access I have all but completed the procedure which uses the /cmd switch to pass known variable on opening the database.

    The difficulty now comes when sending the shortcut to the recipient in form of e-mail via outlook.

    the shortcut format is same as a shortcut link with the relevant /cmd switch and variable:
    "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "S:\Databases\FileListing.accdb" /cmd "abc123"

    But when I try and use that in outlook I don't get the formatting nor hyperlink retained correctly.

    Any pointers as to best way to go about this please?
    Thanks
    Alan

  6. #6
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts
    MS Access 2007
    Outlook 2007
    I have an access database from which I would like to send a mail out to recipients to have them check a specific records details.
    In Access I have all but completed the procedure which uses the /cmd switch to pass known variable on opening the database.

    The difficulty now comes when sending the shortcut to the recipient in form of e-mail via outlook.

    the shortcut format is same as a shortcut link with the relevant /cmd switch and variable:
    "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "S:\Databases\FileListing.accdb" /cmd "abc123"

    But when I try and use that in outlook I don't get the formatting nor hyperlink retained correctly.

    Any pointers as to best way to go about this please?
    Thanks
    Alan

  7. #7
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts
    MS Access 2007
    Outlook 2007
    I have an access database from which I would like to send a mail out to recipients to have them check a specific records details.
    In Access I have all but completed the procedure which uses the /cmd switch to pass known variable on opening the database.

    The difficulty now comes when sending the shortcut to the recipient in form of e-mail via outlook.

    the shortcut format is same as a shortcut link with the relevant /cmd switch and variable:
    "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "S:\Databases\FileListing.accdb" /cmd "abc123"

    But when I try and use that in outlook I don't get the formatting nor hyperlink retained correctly.

    Any pointers as to best way to go about this please?
    Thanks
    Alan

  8. #8
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts
    MS Access 2007
    Outlook 2007
    I have an access database from which I would like to send a mail out to recipients to have them check a specific records details.
    In Access I have all but completed the procedure which uses the /cmd switch to pass known variable on opening the database.

    The difficulty now comes when sending the shortcut to the recipient in form of e-mail via outlook.

    the shortcut format is same as a shortcut link with the relevant /cmd switch and variable:
    "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "S:\Databases\FileListing.accdb" /cmd "abc123"

    But when I try and use that in outlook I don't get the formatting nor hyperlink retained correctly.

    Any pointers as to best way to go about this please?
    Thanks
    Alan

  9. #9
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    I take it this is a follow up to your December thread http://lounge.windowssecrets.com/ind...dpost&p=806061 in the Access forum. Are you using Automation in Access to generate the email? If so, you may need to specify that the email type be HTML or RTF and not the basic text that is the default in such cases.
    Wendell

  10. #10
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    I take it this is a follow up to your December thread http://lounge.windowssecrets.com/ind...dpost&p=806061 in the Access forum. Are you using Automation in Access to generate the email? If so, you may need to specify that the email type be HTML or RTF and not the basic text that is the default in such cases.
    Wendell

  11. #11
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    I take it this is a follow up to your December thread http://lounge.windowssecrets.com/ind...dpost&p=806061 in the Access forum. Are you using Automation in Access to generate the email? If so, you may need to specify that the email type be HTML or RTF and not the basic text that is the default in such cases.
    Wendell

  12. #12
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    I take it this is a follow up to your December thread http://lounge.windowssecrets.com/ind...dpost&p=806061 in the Access forum. Are you using Automation in Access to generate the email? If so, you may need to specify that the email type be HTML or RTF and not the basic text that is the default in such cases.
    Wendell

  13. #13
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    I take it this is a follow up to your December thread http://lounge.windowssecrets.com/ind...dpost&p=806061 in the Access forum. Are you using Automation in Access to generate the email? If so, you may need to specify that the email type be HTML or RTF and not the basic text that is the default in such cases.
    Wendell

  14. #14
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    I take it this is a follow up to your December thread http://lounge.windowssecrets.com/ind...dpost&p=806061 in the Access forum. Are you using Automation in Access to generate the email? If so, you may need to specify that the email type be HTML or RTF and not the basic text that is the default in such cases.
    Wendell

  15. #15
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    I take it this is a follow up to your December thread http://lounge.windowssecrets.com/ind...dpost&p=806061 in the Access forum. Are you using Automation in Access to generate the email? If so, you may need to specify that the email type be HTML or RTF and not the basic text that is the default in such cases.
    Wendell

Page 1 of 3 123 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •